2tcf-unsy

Dataset statistics

Number of variables	13
Number of observations	3144
Missing cells	312
Missing cells (%)	0.8%
Duplicate rows	23
Duplicate rows (%)	0.7%
Total size in memory	788.7 KiB
Average record size in memory	256.9 B

Variable types

NUM	11
CAT	2

Warnings

Dataset has 23 (0.7%) duplicate rows	Duplicates
`Project` has a high cardinality: 520 distinct values	High cardinality
`Est FY16` is highly correlated with `Total`	High correlation
`Total` is highly correlated with `Est FY16` and 6 other fields	High correlation
`6 Year Total` is highly correlated with `Total` and 5 other fields	High correlation
`FY 17` is highly correlated with `Total` and 3 other fields	High correlation
`FY 18` is highly correlated with `Total` and 4 other fields	High correlation
`FY 19` is highly correlated with `Total` and 5 other fields	High correlation
`FY 20` is highly correlated with `Total` and 4 other fields	High correlation
`FY 21` is highly correlated with `Total` and 4 other fields	High correlation
`FY 22` is highly correlated with `FY 21`	High correlation
`Project` is uniformly distributed	Uniform
`Cost Element` is uniformly distributed	Uniform
`Total` has 1045 (33.2%) zeros	Zeros
`Thru FY15` has 1831 (58.2%) zeros	Zeros
`Est FY16` has 1736 (55.2%) zeros	Zeros
`6 Year Total` has 1777 (56.5%) zeros	Zeros
`FY 17` has 2014 (64.1%) zeros	Zeros
`FY 18` has 2066 (65.7%) zeros	Zeros
`FY 19` has 2176 (69.2%) zeros	Zeros
`FY 20` has 2292 (72.9%) zeros	Zeros
`FY 21` has 2384 (75.8%) zeros	Zeros
`FY 22` has 2454 (78.1%) zeros	Zeros
`Beyond 6 Yrs` has 2929 (93.2%) zeros	Zeros

Reproduction

Analysis started	2020-12-13 00:57:46.224035
Analysis finished	2020-12-13 00:57:59.924825
Duration	13.7 seconds
Software version	pandas-profiling v2.9.0
Download configuration	config.yaml

Project
Categorical

HIGH CARDINALITY
UNIFORM

Distinct	520
Distinct (%)	16.7%
Missing	24
Missing (%)	0.8%
Memory size	24.7 KiB

Libraries	6
Chapman Avenue Extended (P500719)	6
Wyngate ES Addition (P116513)	6
Good Hope Neighborhood Recreation Center (P720918)	6
Glen Echo Fire Station Renovation (P450702)	6
Other values (515)	3090

Common Values
Overview

Value	Count	Frequency (%)
Libraries	6	0.2%
Chapman Avenue Extended (P500719)	6	0.2%
Wyngate ES Addition (P116513)	6	0.2%
Good Hope Neighborhood Recreation Center (P720918)	6	0.2%
Glen Echo Fire Station Renovation (P450702)	6	0.2%
MCPS Funding Reconciliation (P076510)	6	0.2%
Public Facilities Roads (P507310)	6	0.2%
Potomac WFP Consent Decree Program (P173801)	6	0.2%
Clarksburg HS Addition (P116505)	6	0.2%
Westbrook ES Addition (P116512)	6	0.2%
Clarksburg Cluster ES (Clarksburg Village Site #1) (P116504)	6	0.2%
General Government	6	0.2%
Neighborhood Traffic Calming (P509523)	6	0.2%
Enterprise Facilities' Improvements (P998773)	6	0.2%
School Based Health & Linkages to Learning Centers (P640400)	6	0.2%
Facility Planning: SM (P809319)	6	0.2%
Traffic Improvements	6	0.2%
Rapid Transit System (P501318)	6	0.2%
Public Safety	6	0.2%
Integrated Justice Information System (P340200)	6	0.2%
Council Office Building Garage (P011601)	6	0.2%
Energy Conservation: MCPS (P796222)	6	0.2%
Community Development	6	0.2%
Water Montgomery County	6	0.2%
Universities at Shady Grove Expansion (P151201)	6	0.2%
Other values (495)	2970	94.5%
(Missing)	24	0.8%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	79
Median length	38
Mean length	38.3740458
Min length	3

Overview of Unicode Properties

Unique unicode characters	72
Unique unicode categories	8 ?
Unique unicode scripts	2 ?
Unique unicode blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Most occurring characters

Value	Count	Frequency (%)
	12108	10.0%
e	8394	7.0%
n	6390	5.3%
i	6054	5.0%
a	6000	5.0%
t	5910	4.9%
o	5604	4.6%
r	5214	4.3%
P	4314	3.6%
0	4026	3.3%
l	3336	2.8%
s	3234	2.7%
(	2940	2.4%
)	2940	2.4%
1	2712	2.2%
d	2532	2.1%
c	2418	2.0%
5	2280	1.9%
S	1806	1.5%
u	1698	1.4%
m	1662	1.4%
C	1560	1.3%
g	1458	1.2%
7	1458	1.2%
6	1446	1.2%
Other values (47)	23154	19.2%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	67440	55.9%
Decimal Number	17292	14.3%
Uppercase Letter	16686	13.8%
Space Separator	12108	10.0%
Open Punctuation	2940	2.4%
Close Punctuation	2940	2.4%
Other Punctuation	870	0.7%
Dash Punctuation	372	0.3%

Most frequent Uppercase Letter characters

Value	Count	Frequency (%)
P	4314	25.9%
S	1806	10.8%
C	1560	9.3%
R	1272	7.6%
A	900	5.4%
M	846	5.1%
B	672	4.0%
E	660	4.0%
F	618	3.7%
W	582	3.5%
L	534	3.2%
T	498	3.0%
D	468	2.8%
G	432	2.6%
I	336	2.0%
H	306	1.8%
N	300	1.8%
O	240	1.4%
U	108	0.6%
V	90	0.5%
J	60	0.4%
K	36	0.2%
Q	30	0.2%
Z	12	0.1%
Y	6	< 0.1%

Most frequent Lowercase Letter characters

Value	Count	Frequency (%)
e	8394	12.4%
n	6390	9.5%
i	6054	9.0%
a	6000	8.9%
t	5910	8.8%
o	5604	8.3%
r	5214	7.7%
l	3336	4.9%
s	3234	4.8%
d	2532	3.8%
c	2418	3.6%
u	1698	2.5%
m	1662	2.5%
g	1458	2.2%
p	1236	1.8%
y	1188	1.8%
h	1062	1.6%
v	1050	1.6%
k	882	1.3%
f	660	1.0%
b	552	0.8%
w	486	0.7%
x	150	0.2%
q	108	0.2%
z	102	0.2%

Most frequent Space Separator characters

Value	Count	Frequency (%)
	12108	100.0%

Most frequent Open Punctuation characters

Value	Count	Frequency (%)
(	2940	100.0%

Most frequent Decimal Number characters

Value	Count	Frequency (%)
0	4026	23.3%
1	2712	15.7%
5	2280	13.2%
7	1458	8.4%
6	1446	8.4%
3	1338	7.7%
8	1206	7.0%
9	1008	5.8%
2	954	5.5%
4	864	5.0%

Most frequent Close Punctuation characters

Value	Count	Frequency (%)
)	2940	100.0%

Most frequent Dash Punctuation characters

Value	Count	Frequency (%)
-	372	100.0%

Most frequent Other Punctuation characters

Value	Count	Frequency (%)
:	432	49.7%
/	126	14.5%
&	120	13.8%
.	90	10.3%
,	66	7.6%
#	30	3.4%
'	6	0.7%

Most occurring scripts

Value	Count	Frequency (%)
Latin	84126	69.7%
Common	36522	30.3%

Most frequent Latin characters

Value	Count	Frequency (%)
e	8394	10.0%
n	6390	7.6%
i	6054	7.2%
a	6000	7.1%
t	5910	7.0%
o	5604	6.7%
r	5214	6.2%
P	4314	5.1%
l	3336	4.0%
s	3234	3.8%
d	2532	3.0%
c	2418	2.9%
S	1806	2.1%
u	1698	2.0%
m	1662	2.0%
C	1560	1.9%
g	1458	1.7%
R	1272	1.5%
p	1236	1.5%
y	1188	1.4%
h	1062	1.3%
v	1050	1.2%
A	900	1.1%
k	882	1.0%
M	846	1.0%
Other values (26)	8106	9.6%

Most frequent Common characters

Value	Count	Frequency (%)
	12108	33.2%
0	4026	11.0%
(	2940	8.0%
)	2940	8.0%
1	2712	7.4%
5	2280	6.2%
7	1458	4.0%
6	1446	4.0%
3	1338	3.7%
8	1206	3.3%
9	1008	2.8%
2	954	2.6%
4	864	2.4%
:	432	1.2%
-	372	1.0%
/	126	0.3%
&	120	0.3%
.	90	0.2%
,	66	0.2%
#	30	0.1%
'	6	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	120648	100.0%

Most frequent ASCII characters

Value	Count	Frequency (%)
	12108	10.0%
e	8394	7.0%
n	6390	5.3%
i	6054	5.0%
a	6000	5.0%
t	5910	4.9%
o	5604	4.6%
r	5214	4.3%
P	4314	3.6%
0	4026	3.3%
l	3336	2.8%
s	3234	2.7%
(	2940	2.4%
)	2940	2.4%
1	2712	2.2%
d	2532	2.1%
c	2418	2.0%
5	2280	1.9%
S	1806	1.5%
u	1698	1.4%
m	1662	1.4%
C	1560	1.3%
g	1458	1.2%
7	1458	1.2%
6	1446	1.2%
Other values (47)	23154	19.2%

Cost Element
Categorical

UNIFORM

Distinct	6
Distinct (%)	0.2%
Missing	24
Missing (%)	0.8%
Memory size	24.7 KiB

Other	520
Planning, Design and Supervision	520
Total Expenditures	520
Construction	520
Site Improvements and Utilities	520

Value	Count	Frequency (%)
Other	520	16.5%
Planning, Design and Supervision	520	16.5%
Total Expenditures	520	16.5%
Construction	520	16.5%
Site Improvements and Utilities	520	16.5%
Land	520	16.5%
(Missing)	24	0.8%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	32
Median length	12
Mean length	16.89312977
Min length	3

Overview of Unicode Properties

Unique unicode characters	30
Unique unicode categories	4 ?
Unique unicode scripts	2 ?
Unique unicode blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Most occurring characters

Value	Count	Frequency (%)
n	6288	11.8%
i	5200	9.8%
e	4680	8.8%
t	4680	8.8%
	3640	6.9%
s	3120	5.9%
a	2624	4.9%
r	2600	4.9%
o	2600	4.9%
d	2080	3.9%
l	1560	2.9%
u	1560	2.9%
p	1560	2.9%
g	1040	2.0%
S	1040	2.0%
v	1040	2.0%
m	1040	2.0%
P	520	1.0%
,	520	1.0%
D	520	1.0%
L	520	1.0%
I	520	1.0%
U	520	1.0%
C	520	1.0%
c	520	1.0%
Other values (5)	2600	4.9%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	43232	81.4%
Uppercase Letter	5720	10.8%
Space Separator	3640	6.9%
Other Punctuation	520	1.0%

Most frequent Uppercase Letter characters

Value	Count	Frequency (%)
S	1040	18.2%
P	520	9.1%
D	520	9.1%
L	520	9.1%
I	520	9.1%
U	520	9.1%
C	520	9.1%
O	520	9.1%
T	520	9.1%
E	520	9.1%

Most frequent Lowercase Letter characters

Value	Count	Frequency (%)
n	6288	14.5%
i	5200	12.0%
e	4680	10.8%
t	4680	10.8%
s	3120	7.2%
a	2624	6.1%
r	2600	6.0%
o	2600	6.0%
d	2080	4.8%
l	1560	3.6%
u	1560	3.6%
p	1560	3.6%
g	1040	2.4%
v	1040	2.4%
m	1040	2.4%
c	520	1.2%
h	520	1.2%
x	520	1.2%

Most frequent Other Punctuation characters

Value	Count	Frequency (%)
,	520	100.0%

Most frequent Space Separator characters

Value	Count	Frequency (%)
	3640	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	48952	92.2%
Common	4160	7.8%

Most frequent Latin characters

Value	Count	Frequency (%)
n	6288	12.8%
i	5200	10.6%
e	4680	9.6%
t	4680	9.6%
s	3120	6.4%
a	2624	5.4%
r	2600	5.3%
o	2600	5.3%
d	2080	4.2%
l	1560	3.2%
u	1560	3.2%
p	1560	3.2%
g	1040	2.1%
S	1040	2.1%
v	1040	2.1%
m	1040	2.1%
P	520	1.1%
D	520	1.1%
L	520	1.1%
I	520	1.1%
U	520	1.1%
C	520	1.1%
c	520	1.1%
O	520	1.1%
h	520	1.1%
Other values (3)	1560	3.2%

Most frequent Common characters

Value	Count	Frequency (%)
	3640	87.5%
,	520	12.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	53112	100.0%

Most frequent ASCII characters

Value	Count	Frequency (%)
n	6288	11.8%
i	5200	9.8%
e	4680	8.8%
t	4680	8.8%
	3640	6.9%
s	3120	5.9%
a	2624	4.9%
r	2600	4.9%
o	2600	4.9%
d	2080	3.9%
l	1560	2.9%
u	1560	2.9%
p	1560	2.9%
g	1040	2.0%
S	1040	2.0%
v	1040	2.0%
m	1040	2.0%
P	520	1.0%
,	520	1.0%
D	520	1.0%
L	520	1.0%
I	520	1.0%
U	520	1.0%
C	520	1.0%
c	520	1.0%
Other values (5)	2600	4.9%

Total
Real number (ℝ)

HIGH CORRELATION
ZEROS

Distinct	1670
Distinct (%)	53.5%
Missing	24
Missing (%)	0.8%
Infinite	0
Infinite (%)	0.0%

Mean	16240.20192
Minimum	-1522
Maximum	1848877
Zeros	1045
Zeros (%)	33.2%
Memory size	24.7 KiB

Quantile statistics

Minimum	-1522
5-th percentile	0
Q1	0
median	618
Q3	5698.75
95-th percentile	66548
Maximum	1848877
Range	1850399
Interquartile range (IQR)	5698.75

Descriptive statistics

Standard deviation	80384.14639
Coefficient of variation (CV)	4.949701165
Kurtosis	211.6527076
Mean	16240.20192
Median Absolute Deviation (MAD)	618
Skewness	12.753861
Sum	50669430
Variance	6461610990
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1045	33.2%
2	17	0.5%
1	16	0.5%
4	10	0.3%
200	10	0.3%
3	8	0.3%
400	8	0.3%
20	7	0.2%
1000	6	0.2%
350	5	0.2%
10	5	0.2%
9	5	0.2%
44	5	0.2%
3000	4	0.1%
6	4	0.1%
5	4	0.1%
22	4	0.1%
500	4	0.1%
100	4	0.1%
227	4	0.1%
1900	4	0.1%
25	4	0.1%
240	4	0.1%
15	4	0.1%
7	4	0.1%
Other values (1645)	1925	61.2%
(Missing)	24	0.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-1522	1	< 0.1%
0	1045	33.2%
1	16	0.5%
2	17	0.5%
3	8	0.3%
4	10	0.3%
5	4	0.1%
6	4	0.1%
7	4	0.1%
8	1	< 0.1%

Value	Count	Frequency (%)
1848877	1	< 0.1%
1495765	1	< 0.1%
1435580	1	< 0.1%
1309810	1	< 0.1%
1182514	1	< 0.1%
975441	1	< 0.1%
870467	1	< 0.1%
823420	1	< 0.1%
790060	1	< 0.1%
719564	1	< 0.1%

Thru FY15
Real number (ℝ_≥0)

ZEROS

Distinct	949
Distinct (%)	30.4%
Missing	24
Missing (%)	0.8%
Infinite	0
Infinite (%)	0.0%

Mean	3889.716667
Minimum	0
Maximum	462612
Zeros	1831
Zeros (%)	58.2%
Memory size	24.7 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	520
95-th percentile	13587.85
Maximum	462612
Range	462612
Interquartile range (IQR)	520

Descriptive statistics

Standard deviation	20591.95192
Coefficient of variation (CV)	5.293946498
Kurtosis	178.9849607
Mean	3889.716667
Median Absolute Deviation (MAD)	0
Skewness	11.51333932
Sum	12135916
Variance	424028484
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1831	58.2%
1	26	0.8%
2	25	0.8%
4	13	0.4%
3	12	0.4%
8	10	0.3%
13	9	0.3%
12	9	0.3%
5	8	0.3%
23	6	0.2%
9	6	0.2%
119	5	0.2%
26	5	0.2%
34	5	0.2%
100	5	0.2%
20	5	0.2%
10	5	0.2%
44	5	0.2%
6	5	0.2%
15	5	0.2%
124	4	0.1%
165	4	0.1%
73	4	0.1%
28	4	0.1%
38	4	0.1%
Other values (924)	1100	35.0%
(Missing)	24	0.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	1831	58.2%
1	26	0.8%
2	25	0.8%
3	12	0.4%
4	13	0.4%
5	8	0.3%
6	5	0.2%
7	3	0.1%
8	10	0.3%
9	6	0.2%

Value	Count	Frequency (%)
462612	1	< 0.1%
397334	1	< 0.1%
326591	1	< 0.1%
263593	1	< 0.1%
256979	1	< 0.1%
248209	1	< 0.1%
201575	1	< 0.1%
192462	1	< 0.1%
191111	2	0.1%
173685	1	< 0.1%

Est FY16
Real number (ℝ)

HIGH CORRELATION
ZEROS

Distinct	948
Distinct (%)	30.4%
Missing	24
Missing (%)	0.8%
Infinite	0
Infinite (%)	0.0%

Mean	2692.137179
Minimum	-18969
Maximum	336606
Zeros	1736
Zeros (%)	55.2%
Memory size	24.7 KiB

Quantile statistics

Minimum	-18969
5-th percentile	0
Q1	0
median	0
Q3	518
95-th percentile	10782
Maximum	336606
Range	355575
Interquartile range (IQR)	518

Descriptive statistics

Standard deviation	14268.78443
Coefficient of variation (CV)	5.300169894
Kurtosis	220.1571038
Mean	2692.137179
Median Absolute Deviation (MAD)	0
Skewness	12.7859342
Sum	8399468
Variance	203598209.1
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1736	55.2%
2	11	0.3%
10	10	0.3%
100	10	0.3%
50	9	0.3%
1	8	0.3%
500	7	0.2%
25	7	0.2%
38	7	0.2%
200	7	0.2%
7	6	0.2%
4	6	0.2%
175	6	0.2%
6	6	0.2%
15	5	0.2%
53	5	0.2%
213	5	0.2%
40151	5	0.2%
300	5	0.2%
20	5	0.2%
103	5	0.2%
42	5	0.2%
514	5	0.2%
8	5	0.2%
347	5	0.2%
Other values (923)	1229	39.1%
(Missing)	24	0.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-18969	1	< 0.1%
-1522	2	0.1%
-174	1	< 0.1%
-158	1	< 0.1%
-120	1	< 0.1%
-81	1	< 0.1%
-37	1	< 0.1%
-33	1	< 0.1%
-25	1	< 0.1%
-18	1	< 0.1%

Value	Count	Frequency (%)
336606	1	< 0.1%
300181	1	< 0.1%
225865	1	< 0.1%
212960	1	< 0.1%
196931	1	< 0.1%
158231	1	< 0.1%
154337	1	< 0.1%
131456	1	< 0.1%
130244	1	< 0.1%
120654	1	< 0.1%

6 Year Total
Real number (ℝ_≥0)

HIGH CORRELATION
ZEROS

Distinct	1019
Distinct (%)	32.7%
Missing	24
Missing (%)	0.8%
Infinite	0
Infinite (%)	0.0%

Mean	9658.348077
Minimum	0
Maximum	1548696
Zeros	1777
Zeros (%)	56.5%
Memory size	24.7 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	1800
95-th percentile	31884.65
Maximum	1548696
Range	1548696
Interquartile range (IQR)	1800

Descriptive statistics

Standard deviation	60022.96174
Coefficient of variation (CV)	6.214619857
Kurtosis	280.8441034
Mean	9658.348077
Median Absolute Deviation (MAD)	0
Skewness	14.77666905
Sum	30134046
Variance	3602755936
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1777	56.5%
200	16	0.5%
6000	12	0.4%
150	11	0.3%
1800	9	0.3%
300	9	0.3%
50	9	0.3%
1000	8	0.3%
3000	7	0.2%
60	7	0.2%
1500	6	0.2%
1200	6	0.2%
7500	6	0.2%
8000	6	0.2%
2000	6	0.2%
540	6	0.2%
600	5	0.2%
20	5	0.2%
33000	5	0.2%
1620	5	0.2%
240	5	0.2%
1100	5	0.2%
3300	5	0.2%
750	5	0.2%
270	5	0.2%
Other values (994)	1174	37.3%
(Missing)	24	0.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	1777	56.5%
1	4	0.1%
2	1	< 0.1%
8	1	< 0.1%
9	1	< 0.1%
10	1	< 0.1%
12	2	0.1%
14	3	0.1%
15	1	< 0.1%
16	1	< 0.1%

Value	Count	Frequency (%)
1548696	1	< 0.1%
1209715	1	< 0.1%
1159159	1	< 0.1%
969554	1	< 0.1%
726544	1	< 0.1%
712236	1	< 0.1%
693176	1	< 0.1%
557574	1	< 0.1%
523156	1	< 0.1%
522633	1	< 0.1%

FY 17
Real number (ℝ)

HIGH CORRELATION
ZEROS

Distinct	678
Distinct (%)	21.7%
Missing	24
Missing (%)	0.8%
Infinite	0
Infinite (%)	0.0%

Mean	2125.673718
Minimum	-6000
Maximum	365379
Zeros	2014
Zeros (%)	64.1%
Memory size	24.7 KiB

Quantile statistics

Minimum	-6000
5-th percentile	0
Q1	0
median	0
Q3	270.75
95-th percentile	7252.8
Maximum	365379
Range	371379
Interquartile range (IQR)	270.75

Descriptive statistics

Standard deviation	13485.97802
Coefficient of variation (CV)	6.344331168
Kurtosis	296.3952312
Mean	2125.673718
Median Absolute Deviation (MAD)	0
Skewness	15.00556452
Sum	6632102
Variance	181871603.2
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	2014	64.1%
50	22	0.7%
1000	20	0.6%
100	19	0.6%
200	18	0.6%
300	16	0.5%
2000	15	0.5%
25	11	0.3%
350	11	0.3%
400	9	0.3%
600	8	0.3%
10	8	0.3%
250	8	0.3%
20	7	0.2%
1250	7	0.2%
60	6	0.2%
120	6	0.2%
500	6	0.2%
150	6	0.2%
3300	5	0.2%
90	5	0.2%
16000	5	0.2%
75	5	0.2%
5000	5	0.2%
450	5	0.2%
Other values (653)	873	27.8%
(Missing)	24	0.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-6000	1	< 0.1%
-3000	1	< 0.1%
0	2014	64.1%
1	4	0.1%
2	3	0.1%
5	2	0.1%
6	2	0.1%
8	2	0.1%
10	8	0.3%
11	1	< 0.1%

Value	Count	Frequency (%)
365379	1	< 0.1%
274030	1	< 0.1%
238616	1	< 0.1%
203751	1	< 0.1%
169477	1	< 0.1%
168490	1	< 0.1%
145521	1	< 0.1%
133804	1	< 0.1%
129881	1	< 0.1%
102000	1	< 0.1%

FY 18
Real number (ℝ)

HIGH CORRELATION
ZEROS

Distinct	665
Distinct (%)	21.3%
Missing	24
Missing (%)	0.8%
Infinite	0
Infinite (%)	0.0%

Mean	1952.871154
Minimum	-6000
Maximum	347787
Zeros	2066
Zeros (%)	65.7%
Memory size	24.7 KiB

Quantile statistics

Minimum	-6000
5-th percentile	0
Q1	0
median	0
Q3	235.25
95-th percentile	6624.95
Maximum	347787
Range	353787
Interquartile range (IQR)	235.25

Descriptive statistics

Standard deviation	12387.09123
Coefficient of variation (CV)	6.343015109
Kurtosis	324.4193324
Mean	1952.871154
Median Absolute Deviation (MAD)	0
Skewness	15.59126993
Sum	6092958
Variance	153440029.2
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	2066	65.7%
100	19	0.6%
50	15	0.5%
1000	13	0.4%
500	13	0.4%
300	13	0.4%
200	12	0.4%
2000	11	0.3%
25	9	0.3%
10	8	0.3%
1250	7	0.2%
400	7	0.2%
45	7	0.2%
125	6	0.2%
700	6	0.2%
600	6	0.2%
450	6	0.2%
270	6	0.2%
550	6	0.2%
250	6	0.2%
90	5	0.2%
175	5	0.2%
150	5	0.2%
22	5	0.2%
17000	5	0.2%
Other values (640)	853	27.1%
(Missing)	24	0.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-6000	1	< 0.1%
-3000	1	< 0.1%
0	2066	65.7%
2	4	0.1%
4	1	< 0.1%
5	2	0.1%
6	2	0.1%
7	3	0.1%
8	1	< 0.1%
10	8	0.3%

Value	Count	Frequency (%)
347787	1	< 0.1%
258988	1	< 0.1%
225699	1	< 0.1%
174165	1	< 0.1%
157231	1	< 0.1%
137269	1	< 0.1%
134664	1	< 0.1%
106785	1	< 0.1%
102858	1	< 0.1%
100420	1	< 0.1%

FY 19
Real number (ℝ)

HIGH CORRELATION
ZEROS

Distinct	593
Distinct (%)	19.0%
Missing	24
Missing (%)	0.8%
Infinite	0
Infinite (%)	0.0%

Mean	1630.662179
Minimum	-6000
Maximum	281039
Zeros	2176
Zeros (%)	69.2%
Memory size	24.7 KiB

Quantile statistics

Minimum	-6000
5-th percentile	0
Q1	0
median	0
Q3	110.5
95-th percentile	4804.4
Maximum	281039
Range	287039
Interquartile range (IQR)	110.5

Descriptive statistics

Standard deviation	11191.51544
Coefficient of variation (CV)	6.863172263
Kurtosis	279.3243029
Mean	1630.662179
Median Absolute Deviation (MAD)	0
Skewness	14.99498751
Sum	5087666
Variance	125250017.9
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	2176	69.2%
300	20	0.6%
50	17	0.5%
100	13	0.4%
1000	12	0.4%
200	12	0.4%
10	10	0.3%
500	10	0.3%
2000	9	0.3%
150	8	0.3%
1250	8	0.3%
250	7	0.2%
600	7	0.2%
25	7	0.2%
4000	6	0.2%
160	6	0.2%
360	6	0.2%
270	6	0.2%
90	6	0.2%
45	6	0.2%
450	5	0.2%
125	5	0.2%
6	5	0.2%
1800	5	0.2%
190	5	0.2%
Other values (568)	743	23.6%
(Missing)	24	0.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-6000	1	< 0.1%
-3000	1	< 0.1%
0	2176	69.2%
2	3	0.1%
3	2	0.1%
5	2	0.1%
6	5	0.2%
9	1	< 0.1%
10	10	0.3%
11	2	0.1%

Value	Count	Frequency (%)
281039	1	< 0.1%
228602	1	< 0.1%
212178	1	< 0.1%
178297	1	< 0.1%
168313	1	< 0.1%
147036	1	< 0.1%
129126	1	< 0.1%
122640	1	< 0.1%
108178	1	< 0.1%
95680	1	< 0.1%

FY 20
Real number (ℝ)

HIGH CORRELATION
ZEROS

Distinct	533
Distinct (%)	17.1%
Missing	24
Missing (%)	0.8%
Infinite	0
Infinite (%)	0.0%

Mean	1535.764744
Minimum	-1316
Maximum	259205
Zeros	2292
Zeros (%)	72.9%
Memory size	24.7 KiB

Quantile statistics

Minimum	-1316
5-th percentile	0
Q1	0
median	0
Q3	33.25
95-th percentile	5014.5
Maximum	259205
Range	260521
Interquartile range (IQR)	33.25

Descriptive statistics

Standard deviation	10207.85879
Coefficient of variation (CV)	6.646759426
Kurtosis	285.8543337
Mean	1535.764744
Median Absolute Deviation (MAD)	0
Skewness	14.96764931
Sum	4791586
Variance	104200381
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	2292	72.9%
300	16	0.5%
1000	14	0.4%
50	12	0.4%
2000	10	0.3%
100	10	0.3%
200	9	0.3%
500	9	0.3%
90	9	0.3%
1250	9	0.3%
10	8	0.3%
250	7	0.2%
700	7	0.2%
4000	6	0.2%
150	6	0.2%
45	6	0.2%
6	6	0.2%
25	6	0.2%
1500	6	0.2%
270	5	0.2%
160	4	0.1%
30	4	0.1%
600	4	0.1%
418	4	0.1%
350	4	0.1%
Other values (508)	647	20.6%
(Missing)	24	0.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-1316	2	0.1%
0	2292	72.9%
2	3	0.1%
3	1	< 0.1%
5	2	0.1%
6	6	0.2%
9	1	< 0.1%
10	8	0.3%
12	2	0.1%
14	1	< 0.1%

Value	Count	Frequency (%)
259205	1	< 0.1%
209647	1	< 0.1%
205236	1	< 0.1%
169368	1	< 0.1%
130060	1	< 0.1%
120483	1	< 0.1%
111821	1	< 0.1%
97069	1	< 0.1%
89791	1	< 0.1%
79553	1	< 0.1%

FY 21
Real number (ℝ_≥0)

HIGH CORRELATION
ZEROS

Distinct	490
Distinct (%)	15.7%
Missing	24
Missing (%)	0.8%
Infinite	0
Infinite (%)	0.0%

Mean	1285.091026
Minimum	0
Maximum	177744
Zeros	2384
Zeros (%)	75.8%
Memory size	24.7 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	4390.6
Maximum	177744
Range	177744
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	7907.592086
Coefficient of variation (CV)	6.153332276
Kurtosis	229.5568907
Mean	1285.091026
Median Absolute Deviation (MAD)	0
Skewness	13.2775633
Sum	4009484
Variance	62530012.6
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	2384	75.8%
50	15	0.5%
100	15	0.5%
300	12	0.4%
10	11	0.3%
200	10	0.3%
1000	10	0.3%
1250	9	0.3%
125	7	0.2%
250	7	0.2%
150	6	0.2%
90	6	0.2%
45	6	0.2%
25	6	0.2%
4000	6	0.2%
270	5	0.2%
6000	5	0.2%
500	5	0.2%
460	4	0.1%
8500	4	0.1%
700	4	0.1%
600	4	0.1%
2000	4	0.1%
140	3	0.1%
8600	3	0.1%
Other values (465)	569	18.1%
(Missing)	24	0.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	2384	75.8%
2	3	0.1%
5	1	< 0.1%
6	2	0.1%
8	1	< 0.1%
10	11	0.3%
12	1	< 0.1%
14	1	< 0.1%
15	1	< 0.1%
18	2	0.1%

Value	Count	Frequency (%)
177744	1	< 0.1%
173199	1	< 0.1%
144716	1	< 0.1%
114618	1	< 0.1%
105814	1	< 0.1%
98866	1	< 0.1%
81163	1	< 0.1%
79792	1	< 0.1%
71930	1	< 0.1%
63553	1	< 0.1%

FY 22
Real number (ℝ_≥0)

HIGH CORRELATION
ZEROS

Distinct	431
Distinct (%)	13.8%
Missing	24
Missing (%)	0.8%
Infinite	0
Infinite (%)	0.0%

Mean	1128.284615
Minimum	0
Maximum	190630
Zeros	2454
Zeros (%)	78.1%
Memory size	24.7 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	3281
Maximum	190630
Range	190630
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	7379.075902
Coefficient of variation (CV)	6.540083771
Kurtosis	240.5057784
Mean	1128.284615
Median Absolute Deviation (MAD)	0
Skewness	13.46482281
Sum	3520248
Variance	54450761.17
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	2454	78.1%
300	14	0.4%
50	13	0.4%
100	11	0.3%
200	11	0.3%
1000	10	0.3%
150	9	0.3%
10	9	0.3%
1250	9	0.3%
250	8	0.3%
125	7	0.2%
25	6	0.2%
45	6	0.2%
90	6	0.2%
270	5	0.2%
500	5	0.2%
80	5	0.2%
460	4	0.1%
1500	4	0.1%
4000	4	0.1%
3000	4	0.1%
1800	4	0.1%
700	4	0.1%
20000	3	0.1%
335	3	0.1%
Other values (406)	502	16.0%
(Missing)	24	0.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	2454	78.1%
2	3	0.1%
3	1	< 0.1%
5	1	< 0.1%
6	3	0.1%
10	9	0.3%
12	1	< 0.1%
14	2	0.1%
15	1	< 0.1%
18	2	0.1%

Value	Count	Frequency (%)
190630	1	< 0.1%
125625	1	< 0.1%
118994	1	< 0.1%
117542	1	< 0.1%
97294	1	< 0.1%
93732	1	< 0.1%
85820	1	< 0.1%
67531	2	0.1%
65282	1	< 0.1%
61744	1	< 0.1%

Beyond 6 Yrs
Real number (ℝ_≥0)

ZEROS

Distinct	154
Distinct (%)	4.9%
Missing	24
Missing (%)	0.8%
Infinite	0
Infinite (%)	0.0%

Mean	1194.888462
Minimum	0
Maximum	246835
Zeros	2929
Zeros (%)	93.2%
Memory size	24.7 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	502
Maximum	246835
Range	246835
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	10647.41339
Coefficient of variation (CV)	8.91080108
Kurtosis	225.4045121
Mean	1194.888462
Median Absolute Deviation (MAD)	0
Skewness	13.57698914
Sum	3728052
Variance	113367412
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	2929	93.2%
1586	4	0.1%
125	4	0.1%
109366	4	0.1%
50	3	0.1%
400	3	0.1%
7458	3	0.1%
6530	3	0.1%
501	3	0.1%
11684	2	0.1%
600	2	0.1%
780	2	0.1%
7031	2	0.1%
1199	2	0.1%
44123	2	0.1%
778	2	0.1%
52594	2	0.1%
9690	2	0.1%
232	2	0.1%
1536	2	0.1%
1216	2	0.1%
240	2	0.1%
17058	2	0.1%
7950	2	0.1%
521	2	0.1%
Other values (129)	132	4.2%
(Missing)	24	0.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	2929	93.2%
11	1	< 0.1%
21	1	< 0.1%
40	1	< 0.1%
50	3	0.1%
52	1	< 0.1%
59	1	< 0.1%
80	1	< 0.1%
85	1	< 0.1%
91	1	< 0.1%

Value	Count	Frequency (%)
246835	1	< 0.1%
224573	1	< 0.1%
167072	1	< 0.1%
147635	1	< 0.1%
134610	1	< 0.1%
131668	1	< 0.1%
121990	1	< 0.1%
109366	4	0.1%
97030	1	< 0.1%
87806	1	< 0.1%

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

First rows

	Project	Cost Element	Total	Thru FY15	Est FY16	6 Year Total	FY 17	FY 18	FY 19
0	Council Office Building Renovations (P010100)	Planning, Design and Supervision	2553.0	669.0	334.0	1550.0	1000.0	550.0	0.0
1	Council Office Building Renovations (P010100)	Land	4.0	4.0	0.0	0.0	0.0	0.0	0.0
2	Council Office Building Renovations (P010100)	Site Improvements and Utilities	2.0	2.0	0.0	0.0	0.0	0.0	0.0
3	Council Office Building Renovations (P010100)	Construction	36414.0	3272.0	293.0	32849.0	19785.0	13064.0	0.0
4	Council Office Building Renovations (P010100)	Other	1218.0	8.0	0.0	1210.0	610.0	600.0	0.0
5	Council Office Building Renovations (P010100)	Total Expenditures	40191.0	3955.0	627.0	35609.0	21395.0	14214.0	0.0
6	Council Office Building Garage (P011601)	Planning, Design and Supervision	875.0	0.0	159.0	716.0	395.0	263.0	58.0
7	Council Office Building Garage (P011601)	Land	0.0	0.0	0.0	0.0	0.0	0.0	0.0
8	Council Office Building Garage (P011601)	Site Improvements and Utilities	0.0	0.0	0.0	0.0	0.0	0.0	0.0
9	Council Office Building Garage (P011601)	Construction	3884.0	0.0	0.0	3884.0	1748.0	2136.0	0.0

Last rows

	Project	Cost Element	Total	Est FY16
3134	Mass Transit (SC96)	Site Improvements and Utilities	0.0	0.0
3135	Mass Transit (SC96)	Construction	5294.0	5294.0
3136	Mass Transit (SC96)	Other	0.0	0.0
3137	Mass Transit (SC96)	Total Expenditures	5317.0	5317.0
3138	WMATA	Planning, Design and Supervision	23.0	23.0
3139	WMATA	Land	0.0	0.0
3140	WMATA	Site Improvements and Utilities	0.0	0.0
3141	WMATA	Construction	5294.0	5294.0
3142	WMATA	Other	0.0	0.0
3143	WMATA	Total Expenditures	5317.0	5317.0

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent Uppercase Letter characters

Most frequent Lowercase Letter characters

Most frequent Space Separator characters

Most frequent Open Punctuation characters

Most frequent Decimal Number characters

Most frequent Close Punctuation characters

Most frequent Dash Punctuation characters

Most frequent Other Punctuation characters

Most occurring scripts

Most frequent Latin characters

Most frequent Common characters

Most occurring blocks

Most frequent ASCII characters

Most occurring characters

Most occurring categories

Most frequent Uppercase Letter characters

Most frequent Lowercase Letter characters

Most frequent Other Punctuation characters

Most frequent Space Separator characters

Most occurring scripts

Most frequent Latin characters

Most frequent Common characters

Most occurring blocks

Most frequent ASCII characters

Interactions

Correlations

Pearson's r

Spearman's ρ

Kendall's τ

Phik (φk)

Missing values

Sample

First rows

Last rows